select p2c.products_id, pd.products_name, if(ac.cities_name is null, '', ac.cities_name) as cities_name, p2c.country_id, ar.regions_name, pd.img_num, pd.img_type, pd.img_path, cd.categories_name, pd.`color` from ((products_to_categories p2c left join products_short_d pd on p2c.products_id = pd.products_id, categories c, categories_description cd) left join a_regions ar on p2c.region_id = ar.regions_id) left join a_cities ac on p2c.city_id = ac.cities_id where p2c.status_id = '1' and p2c.categories_id = c.categories_id and c.categories_id = cd.categories_id and pd.products_id in (15057621232625,1236426,1317899,1318008,1369452,1387622,1388109,1388499,1393457) order by field(p2c.products_id, 15057621232625,1236426,1317899,1318008,1369452,1387622,1388109,1388499,1393457)